CREATE TABLE [dbo].[Purge_Ctrl_ie]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Purge_Ctrl_ie_ID] DEFAULT (''),
[STATUS] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Purge_Ctrl_ie_STATUS] DEFAULT (''),
[CERT_REGISTER_BTID] [bit] NOT NULL CONSTRAINT [DF_Purge_Ctrl_ie_CERT_REGISTER_BTID] DEFAULT ((0)),
[INVOICE_BALANCE] [bit] NOT NULL CONSTRAINT [DF_Purge_Ctrl_ie_INVOICE_BALANCE] DEFAULT ((0)),
[NAME_BT_COID] [bit] NOT NULL CONSTRAINT [DF_Purge_Ctrl_ie_NAME_BT_COID] DEFAULT ((0)),
[NAME_FIN_BTID] [bit] NOT NULL CONSTRAINT [DF_Purge_Ctrl_ie_NAME_FIN_BTID] DEFAULT ((0)),
[OPEN_ORDERS] [bit] NOT NULL CONSTRAINT [DF_Purge_Ctrl_ie_OPEN_ORDERS] DEFAULT ((0)),
[REFERRAL_ORPHAN] [bit] NOT NULL CONSTRAINT [DF_Purge_Ctrl_ie_REFERRAL_ORPHAN] DEFAULT ((0)),
[SUBSCRIPTION] [bit] NOT NULL CONSTRAINT [DF_Purge_Ctrl_ie_SUBSCRIPTION] DEFAULT ((0)),
[OPP_PROSPECT] [bit] NOT NULL CONSTRAINT [DF_Purge_Ctrl_ie_OPP_PROSPECT] DEFAULT ((0))
) ON [PRIMARY]

GO